﻿alter database [Test] set single_user with rollback immediate;
go

alter database [Test] COLLATE Chinese_PRC_CS_AS;
go

alter database [Test] set multi_user;
go

INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'xxyw', '校园要闻');
INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'jydt', '教研动态');
INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'ybhd', '院部活动');
INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'spxw', '视频新闻');
INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'mtbd', '媒体报道');
INSERT INTO [Category] ( [Mark], [Name]) VALUES( 'xycf', '校友采风');

INSERT INTO [Info]
( [Title], [Content], [Publish_Time], [Author], [Click_Number], [Category_Mark])
VALUES( '思政', '九江学院', '2020-05-21 00:00:00.0', '章', 520, 'xxyw');
INSERT INTO [Info]
([Title], [Content], [Publish_Time], [Author], [Click_Number], [Category_Mark])
VALUES( '学习', '我校准备', '2020-05-21 00:00:00.0', '章', 222, 'jydt');
INSERT INTO [Info]
([Title], [Content], [Publish_Time], [Author], [Click_Number], [Category_Mark])
VALUES( '学习', '我校准备', '2020-05-21 00:00:00.0', '章', 33, 'jydt');
INSERT INTO [Info]
([Title], [Content], [Publish_Time], [Author], [Click_Number], [Category_Mark])
VALUES( '学习', '我校准备', '2020-05-21 00:00:00.0', '章', 22, 'xxyw');

